﻿CREATE TABLE [dbo].[ClaimPaymentLineItems]
(
[ClaimPaymentLineItemIDKey] [int] NOT NULL IDENTITY(1, 1),
[ClaimPaymentIDKey] [int] NULL,
[PatientControlNumber] [nvarchar] (38) NULL,
[LineItemChargeAmount] [money] NULL,
[LineItemProviderPaymentAmount] [money] NULL,
[NationalUniformBillingCommitteeRevenueCode] [nvarchar] (48) NULL,
[UnitsOfServicePaidCount] [decimal] (18, 0) NULL,
[PayerClaimControlNumber] [nvarchar] (30) NULL,
[ProductOrServiceIDQualifier] [nvarchar] (2) NULL,
[ProcedureCode] [nvarchar] (48) NULL,
[DateProcessed] [datetime] NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[SubscriberHierarchicalIDNumber] [int] NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[AssignedNumber] [int] NULL,
[ProcedureModifier1] [nvarchar] (2) NULL,
[ProcedureModifier2] [nvarchar] (2) NULL,
[ProcedureModifier3] [nvarchar] (2) NULL,
[ProcedureModifier4] [nvarchar] (2) NULL,
[ProcedureCodeDescription] [nvarchar] (80) NULL,
[AdjProcedureModifier1] [nvarchar] (2) NULL,
[AdjProcedureModifier2] [nvarchar] (2) NULL,
[AdjProcedureModifier3] [nvarchar] (2) NULL,
[AdjProcedureModifier4] [nvarchar] (2) NULL,
[AdjProcedureCodeDescription] [nvarchar] (80) NULL,
[AdjProductOrServiceIDQualifier] [nvarchar] (2) NULL,
[AdjProcedureCode] [nvarchar] (48) NULL,
[OriginalUnitsOfServiceCount] [nvarchar] (15) NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


